﻿using DFGK.IService;
using DFGK.Repository;
using DFGK.Service;
using DFGK_WMS.Common;
using DFGK_WMS.Model.Models;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using NPOI.HSSF.UserModel;
using NPOI.SS.UserModel;
using NPOI.XSSF.UserModel;
using System.Collections.Generic;
using System.Security.Claims;
using System.Xml.Linq;

namespace DFGK_WMS.WebAPI.Controllers.PC.基础数据
{
    /// <summary>
    /// 供应商
    /// </summary>
    [Route("api/[controller]/[action]")]
    [ApiController]
    [ApiExplorerSettings(GroupName = "PC")]
    public class SupplierController : BaseController
    {
        private readonly ISupplierService supplierService;
        /// <summary>
        /// 
        /// </summary>
        /// <param name="environment"></param>
        /// <param name="supplierService"></param>
        public SupplierController(IWebHostEnvironment environment, ISupplierService supplierService) : base(environment)
        {
            this.supplierService = supplierService;
        }

        /// <summary>
        /// 查询供应商
        /// </summary>
        /// <param name="name"></param>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        [HttpGet]
        public IActionResult GetAllSupplier(string? name, int pageIndex = 1, int pageSize = 5)
        {
            if (pageIndex <= 0 || pageSize <= 0)
            {
                BaseResult.Result("400", "分页条件有误！");
            }
            var list = supplierService.GetAllSupplier(name, pageIndex, pageSize, out var totalCount);
            if (list != null)
            {
                return Ok(BaseResult.Result(list, "查询成功！", "200", totalCount));
            }
            return Ok(BaseResult.Result(null, "查询失败！", "500", 0));
        }
        /// <summary>
        /// 根据供应商id查看供应商
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        [HttpGet]
        public IActionResult GetSupplierById(long id)
        {
            if (id <= 0)
            {
                return Ok(BaseResult.Result("400", "Id有误！"));
            }
            var res = supplierService.GetSupplierById(id);
            if (res != null)
                return Ok(BaseResult.Result(res, "200", 0));
            return Ok(BaseResult.Result(null, "200", 0));
        }

        /// <summary>
        /// 添加供应商
        /// </summary>
        /// <param name="supplier"></param>
        /// <returns></returns>
        [HttpPost]
        public IActionResult AddSupplier(Supplier supplier)
        {
            if (string.IsNullOrEmpty(supplier.Code) || supplier.Code.Length <= 0)
            {
                return Ok(BaseResult.Result("400", "编码不能为空！"));
            }
            supplier.CreateUserId = base.BaseGetNowUserId();
            supplier.CreateUserName = base.BaseGetNowUserName();
            string message = "";
            var res = supplierService.AddSupplier(supplier, out message);
            if (res)
            {
                return Ok(BaseResult.Result(true, "添加成功！", "200"));
            }
            return Ok(BaseResult.Result(false, "添加失败！" + message, "500"));
        }
        /// <summary>
        /// 修改供应商
        /// </summary>
        /// <param name="supplier"></param>
        /// <returns></returns>
        [HttpPut]
        public IActionResult UpdSupplier(Supplier supplier)
        {
            if (supplier.Id <= 0)
            {
                return Ok(BaseResult.Result("400", "Id有误！"));
            }
            if (string.IsNullOrEmpty(supplier.Code) || supplier.Code.Length <= 0)
            {
                return Ok(BaseResult.Result("400", "编码不能为空！"));
            }
            supplier.ModifyUserId = base.BaseGetNowUserId();
            supplier.ModifyUserName = base.BaseGetNowUserName();
            string message = "";
            var res = supplierService.UpdSupplier(supplier, out message);
            if (res)
            {
                return Ok(BaseResult.Result(true, "修改成功！", "200"));
            }
            return Ok(BaseResult.Result(false, "修改失败！" + message, "500"));
        }
        /// <summary>
        /// 删除供应商
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        [HttpDelete]
        public IActionResult DelSUpplier(long id)
        {
            if (id <= 0)
            {
                return Ok(BaseResult.Result("400", "Id有误！"));
            }
            var res = supplierService.DelSupplier(id);
            if (res)
            {
                return Ok(BaseResult.Result(true, "删除成功！", "200"));
            }
            return Ok(BaseResult.Result(false, "删除失败！", "500"));
        }
        /// <summary>
        /// 批量删除供应商
        /// </summary>
        /// <param name="idList"></param>
        /// <returns></returns>
        [HttpDelete]
        public IActionResult DelSUpplierList(long[] idList)
        {
            if (idList.Length <= 0)
            {
                return Ok(BaseResult.Result("400", "Id有误！"));
            }
            var daRes = true;
            foreach (var id in idList)
            {
                var res = supplierService.DelSupplier(id);
                if (!res)
                {
                    daRes = false;
                    break;
                }
            }
            if (daRes)
            {
                return Ok(BaseResult.Result(true, "删除成功！", "200"));
            }
            return Ok(BaseResult.Result(false, "删除失败！", "500"));
        }


        /// <summary>
        /// 供应商导入
        /// </summary>
        /// <param name="file"></param>
        /// <returns></returns>
        [HttpPost]
        public IActionResult SupplierImport(IFormFile file)
        {
            try
            {
                // 检查文件是否为空
                if (file == null || file.Length == 0)
                {
                    return Ok(BaseResult.Result("400", "没有选择文件或文件为空"));
                }
                string message = "";
                var postFile = Request.Form.Files[0];
                string extName = Path.GetExtension(postFile.FileName);
                if (!new string[] { ".xls", ".xlsx" }.Contains(extName))
                {
                    return Ok(BaseResult.Result("400", "必须是Excel文件"));
                }
                string uname = HttpContext.User.FindFirstValue("UserName");
                int uid = Convert.ToInt32(HttpContext.User.FindFirstValue("Id"));
                MemoryStream ms = new MemoryStream();
                postFile.CopyTo(ms);
                ms.Position = 0;
                IWorkbook wb = null;
                if (extName.ToLower().Equals(".xls")) // 97-2003版本
                {
                    wb = new HSSFWorkbook(ms);
                }
                else
                {
                    wb = new XSSFWorkbook(ms); // 2007以上版本
                }

                ISheet sheet = wb.GetSheetAt(0);

                //总行数（0开始）
                int totalRow = sheet.LastRowNum;
                // 总列数（1开始）
                int totalColumn = sheet.GetRow(0).LastCellNum;

                List<Supplier> stuList = new();
                for (int i = 1; i <= totalRow; i++)
                {

                    IRow row = sheet.GetRow(i);
                    string? SuppliersName = row.GetCell(0)?.StringCellValue;
                    string? SuppliersCode = row.GetCell(1)?.StringCellValue;
                    string? Contact = row.GetCell(2)?.StringCellValue;
                    string? ContactMobile = row.GetCell(3)?.StringCellValue;
                    string? Email = row.GetCell(4)?.StringCellValue;
                    string? AddrDetail = row.GetCell(5)?.StringCellValue;
                    string? Remark = row.GetCell(6)?.StringCellValue;
                    string? TypeName = row.GetCell(7)?.StringCellValue;
                    

                    var supplier = new Supplier
                    {
                        Code = SuppliersCode,
                        Name = SuppliersName,
                        Contact = Contact,
                        ContactMobile = ContactMobile,
                        Email = Email,
                        AddrDetail = AddrDetail,
                        Remark = Remark,
                        DisplayOrder = 1,
                        TypeName = TypeName,

                    };
                    stuList.Add(supplier);
                }
                if (stuList.Count <= 0)
                {
                    //message = "文件信息为空或别写字段为空！";
                    return Ok(BaseResult.Result(false, "导入失败！" + message, "500"));
                }
                bool result = supplierService.AddSuppliers(stuList);
                wb.Close();
                if (result)
                {
                    return Ok(BaseResult.Result(true, "导入成功！" + message, "200"));
                }
                return Ok(BaseResult.Result(stuList, "导入失败！", "500"));
            }
            catch (Exception)
            {
                throw;
            }
        }


        /// <summary>
        /// 供应商导出
        /// </summary>
        /// <returns></returns>
        [HttpGet]
        public IActionResult SuppliersDown()
        {
            var list = supplierService.GetAllSupplier();
            if (list != null)
                return SuppliersDown(list);
            else
                return Ok();
        }

        /// <summary>
        /// 供应商报价分析
        /// </summary>
        /// <param name="purMsg"></param>
        /// <param name="suppliers"></param>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        [HttpGet]
        public IActionResult GetSupplierMsg(string? purMsg,string? suppliers, int pageIndex = 1, int pageSize = 10)
        {
            if (pageIndex <= 0 || pageSize <= 0)
            {
                BaseResult.Result("400", "分页条件有误！");
            }
            var list = supplierService.GetSupplierMsg(purMsg,suppliers, pageIndex, pageSize, out var totalCount);
            if (list != null)
            {
                return Ok(BaseResult.Result(list, "查询成功！", "200", totalCount));
            }
            return Ok(BaseResult.Result(null, "查询失败！", "500", 0));
        }
    }
}
